Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_HIST_SQLBIND

`DBA_HIST_SQLBIND` displays historical information on bind variables used by SQL cursors. This view contains snapshots of `V$SQL_BIND_CAPTURE`.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SNAP_ID` | `NUMBER` |  | Unique snapshot ID
`DBID` | `NUMBER` |  | Database ID for the snapshot
`INSTANCE_NUMBER` | `NUMBER` |  | Instance number for the snapshot
`SQL_ID` | `VARCHAR2(13)` |  | SQL identifier of the parent cursor in the library cache
`NAME` | `VARCHAR2(30)` |  | Name of the bind variable
`POSITION` | `NUMBER` |  | Position of the bind variable in the SQL statement
`DUP_POSITION` | `NUMBER` |  | If the binding is performed by name and the bind variable is duplicated, then this column gives the position of the primary bind variable.
`DATATYPE` | `NUMBER` |  | Internal identifier for the bind datatype
`DATATYPE_STRING` | `VARCHAR2(15)` |  | Textual representation of the bind datatype
`CHARACTER_SID` | `NUMBER` |  | National character set identifier
`PRECISION` | `NUMBER` |  | Precision (for numeric binds)
`SCALE` | `NUMBER` |  | Scale (for numeric binds)
`MAX_LENGTH` | `NUMBER` |  | Maximum bind length
`WAS_CAPTURED` | `VARCHAR2(3)` |  | Indicates whether the bind value was captured (`YES`) or not (`NO`)
`LAST_CAPTURED` | `DATE` |  | Date when the bind value was captured. Bind values are captured when SQL statements are executed. To limit the overhead, binds are captured at most every 15 minutes for a given cursor.
`VALUE_STRING` | `VARCHAR2(4000)` |  | Value of the bind represented as a string
`VALUE_ANYDATA` | `ANYDATA` |  | Value of the bind represented using the self-descriptive `Sys.AnyData` datatype. This representation is useful to programmatically decode the value of the bind variable.